Problem Note 46272: The Notify_Manager macro in SAS® Anti-Money Laundering might generate errors or warnings
In the Notify_Manager macro, alert IDs are stored in a SAS character string
with the maximum allowed length in SAS 32767 characters.
Placing the alert IDs in string limits the number of alert IDs sent out to
managers. This can be an issue for large financial institutions.
For example, if you have alert IDs with a length of 8, plus the delimiter = 9
characters, then the string can hold approximately 3640 alert IDs (32767/9 = 3640.8).
This number is higher if the alert IDs are less than 8 characters.
The alert ID string is used to update the FSK_ALERT_EVENT table. It is not
used to generate the e-mail attachments that contain the list of alerts. So
there is no limitation to the number of alerts sent to each user.
However, if a user has more alert IDs than the alert ID string can handle,
for example 4000 or more, then the code might generate the following warning and error messages as it tries to update the FSK_ALERT_EVENT table. The error is due to the NOT NULL constraint placed on the ALERT_ID in FSK_ALERT_EVENT.
WARNING: In a call to the CATX function, the buffer allocated for the result was
not long enough to contain the concatenation of all the arguments.
ERROR: ERROR: ERROR: ORACLE execute error: ORA-01400: cannot insert NULL into
("DEVCTR"."FSK_ALERT_EVENT"."ALERT_ID"). With the occurrence of
the above ERROR, the error limit of 1 set by the ERRLIMIT= option has been reached.ROLLBACK has been issued(Any Rows processed after the last COMMIT are lost).
This error might impact the alert IDs that were truncated from the list such that they do not
have a notification event record in FSK_ALERT_EVENT. This error might also cause SAS to stop processing and sending e-mails out to the investigators.
Operating System and Release Information
| SAS System | SAS Anti-Money Laundering | Microsoft Windows 2000 Advanced Server | 2.1 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Datacenter Server | 2.1 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Server | 2.1 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Professional | 2.1 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows NT Workstation | 2.1 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Datacenter Edition | 2.1 | 5.1 | 9.1 TS1M3 SP4 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 2.1 | 5.1 | 9.1 TS1M3 SP4 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 2.1 | 5.1 | 9.1 TS1M3 SP4 | 9.3 TS1M0 |
| Microsoft Windows XP Professional | 2.1 | 5.1 | 9.1 TS1M3 SP4 | 9.3 TS1M0 |
| Windows Vista | 2.1 | 5.1 | 9.1 TS1M3 SP4 | 9.3 TS1M0 |
| Windows Vista for x64 | 2.1 | 5.1 | 9.1 TS1M3 SP4 | 9.3 TS1M0 |
| 64-bit Enabled AIX | 2.1 | 5.1 | 9.1 TS1M3 SP4 | 9.3 TS1M0 |
| 64-bit Enabled HP-UX | 2.1 | 5.1 | 9.1 TS1M3 SP4 | 9.3 TS1M0 |
| 64-bit Enabled Solaris | 2.1 | 5.1 | 9.1 TS1M3 SP4 | 9.3 TS1M0 |
| Linux | 2.1 | 5.1 | 9.1 TS1M3 SP4 | 9.3 TS1M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
The Notify_Manager macro in SAS Anti-Money Laundering might generate errors or warnings when the number of alert IDs exceed the SAS character string limitation of 32767 characters.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2012-04-27 14:29:29 |
| Date Created: | 2012-04-11 08:40:28 |
